<h2>Step 1 - Create Jobs Table</h2>
<?php
$sql = "CREATE TABLE IF NOT EXISTS `jobs` (
  `JobID` int(255) NOT NULL AUTO_INCREMENT,
  `JobTitle` varchar(50) NOT NULL,
  `Employer` varchar(50) NOT NULL,
  `ContactNumber` varchar(15) NOT NULL,
  `ContactEmail` varchar(30) NOT NULL,
  `Wage` varchar(50) NOT NULL,
  `Hours` varchar(50) NOT NULL,
  `Description` varchar(500) NOT NULL,
  `Timestamp` date NOT NULL,
  PRIMARY KEY (`JobID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$result = mysql_query($sql);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

echo "Step 1 Completed, Jobs Table has been created.<br /><meta http-equiv='refresh' content='3;URL=index.php?step=2'><br />
<a href='index.php?step=2'>If you are not redirected in 3 seconds click here</a>";

?>
